Overview
Brought to you by YData
Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 2475 |
| Missing cells | 10 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 212.8 KiB |
| Average record size in memory | 88.1 B |
Variable types
| Numeric | 7 |
|---|---|
| Text | 3 |
| Categorical | 1 |
Category is highly overall correlated with Category ID and 2 other fields | High correlation |
Category ID is highly overall correlated with Category and 2 other fields | High correlation |
Cluster ID is highly overall correlated with Category and 2 other fields | High correlation |
Product ID is highly overall correlated with Category and 2 other fields | High correlation |
Price is highly skewed (γ1 = 28.64400963) | Skewed |
Product ID has unique values | Unique |
Price has 150 (6.1%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-12 03:20:41.240774 |
|---|---|
| Analysis finished | 2024-11-12 03:20:46.926412 |
| Duration | 5.69 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
Product ID
Real number (ℝ)
High correlation  Unique 
| Distinct | 2475 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26449.261 |
| Minimum | 5 |
|---|---|
| Maximum | 47341 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.5 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 1712.1 |
| Q1 | 15046 |
| median | 27943 |
| Q3 | 37893.5 |
| 95-th percentile | 45543.3 |
| Maximum | 47341 |
| Range | 47336 |
| Interquartile range (IQR) | 22847.5 |
Descriptive statistics
| Standard deviation | 13565.141 |
|---|---|
| Coefficient of variation (CV) | 0.51287411 |
| Kurtosis | -0.97393913 |
| Mean | 26449.261 |
| Median Absolute Deviation (MAD) | 11280 |
| Skewness | -0.3306697 |
| Sum | 65461920 |
| Variance | 1.8401305 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 43860 | 1 | < 0.1% |
| 33762 | 1 | < 0.1% |
| 26365 | 1 | < 0.1% |
| 17098 | 1 | < 0.1% |
| 15388 | 1 | < 0.1% |
| 12451 | 1 | < 0.1% |
| 16342 | 1 | < 0.1% |
| 44930 | 1 | < 0.1% |
| 37688 | 1 | < 0.1% |
| 30825 | 1 | < 0.1% |
| Other values (2465) | 2465 |
| Value | Count | Frequency (%) |
| 5 | 1 | |
| 14 | 1 | |
| 41 | 1 | |
| 62 | 1 | |
| 71 | 1 | |
| 93 | 1 | |
| 97 | 1 | |
| 120 | 1 | |
| 131 | 1 | |
| 140 | 1 |
| Value | Count | Frequency (%) |
| 47341 | 1 | |
| 47299 | 1 | |
| 47285 | 1 | |
| 47280 | 1 | |
| 47274 | 1 | |
| 47267 | 1 | |
| 47266 | 1 | |
| 47235 | 1 | |
| 47202 | 1 | |
| 47188 | 1 |
ProductName
Text
| Distinct | 2457 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.5 KiB |
Length
| Max length | 192 |
|---|---|
| Median length | 121 |
| Mean length | 52.662626 |
| Min length | 9 |
Unique
| Unique | 2440 ? |
|---|---|
| Unique (%) | 98.6% |
Sample
| 1st row | bosch serie 4 kil22vf30g integrated fridge |
|---|---|
| 2nd row | sony kd75xf8596bu 75 4k hdr ultra hd smart android led tv amazon alexa |
| 3rd row | sony xperia xa2 ultra black 6 32gb 4g unlocked sim free |
| 4th row | pentax k 1 body hd 24 70mm f/2 8 ed sdm wr |
| 5th row | samsung ue75mu7000txxu 75 inch 7 series led smart tv black/silver |
| Value | Count | Frequency (%) |
| fridge | 460 | 2.2% |
| freezer | 434 | 2.0% |
| white | 388 | 1.8% |
| in | 266 | 1.2% |
| black | 265 | 1.2% |
| a | 243 | 1.1% |
| free | 240 | 1.1% |
| bosch | 220 | 1.0% |
| tv | 201 | 0.9% |
| processor | 185 | 0.9% |
| Other values (4308) | 18399 |
Most occurring characters
| Value | Count | Frequency (%) |
| 18826 | 14.4% | |
| e | 11407 | 8.8% |
| r | 7515 | 5.8% |
| i | 7038 | 5.4% |
| s | 6111 | 4.7% |
| a | 6084 | 4.7% |
| t | 5073 | 3.9% |
| n | 5042 | 3.9% |
| l | 4635 | 3.6% |
| o | 4498 | 3.5% |
| Other values (29) | 54111 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 130340 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 18826 | 14.4% | |
| e | 11407 | 8.8% |
| r | 7515 | 5.8% |
| i | 7038 | 5.4% |
| s | 6111 | 4.7% |
| a | 6084 | 4.7% |
| t | 5073 | 3.9% |
| n | 5042 | 3.9% |
| l | 4635 | 3.6% |
| o | 4498 | 3.5% |
| Other values (29) | 54111 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 130340 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 18826 | 14.4% | |
| e | 11407 | 8.8% |
| r | 7515 | 5.8% |
| i | 7038 | 5.4% |
| s | 6111 | 4.7% |
| a | 6084 | 4.7% |
| t | 5073 | 3.9% |
| n | 5042 | 3.9% |
| l | 4635 | 3.6% |
| o | 4498 | 3.5% |
| Other values (29) | 54111 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 130340 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 18826 | 14.4% | |
| e | 11407 | 8.8% |
| r | 7515 | 5.8% |
| i | 7038 | 5.4% |
| s | 6111 | 4.7% |
| a | 6084 | 4.7% |
| t | 5073 | 3.9% |
| n | 5042 | 3.9% |
| l | 4635 | 3.6% |
| o | 4498 | 3.5% |
| Other values (29) | 54111 |
Merchant ID
Real number (ℝ)
| Distinct | 182 |
|---|---|
| Distinct (%) | 7.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 121.18303 |
| Minimum | 1 |
|---|---|
| Maximum | 367 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 17 |
| median | 88 |
| Q3 | 250 |
| 95-th percentile | 314 |
| Maximum | 367 |
| Range | 366 |
| Interquartile range (IQR) | 233 |
Descriptive statistics
| Standard deviation | 116.39138 |
|---|---|
| Coefficient of variation (CV) | 0.96045936 |
| Kurtosis | -1.0860371 |
| Mean | 121.18303 |
| Median Absolute Deviation (MAD) | 74 |
| Skewness | 0.66218284 |
| Sum | 299928 |
| Variance | 13546.952 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 170 | 6.9% |
| 6 | 125 | 5.1% |
| 298 | 124 | 5.0% |
| 119 | 97 | 3.9% |
| 7 | 96 | 3.9% |
| 17 | 84 | 3.4% |
| 293 | 73 | 2.9% |
| 31 | 66 | 2.7% |
| 294 | 61 | 2.5% |
| 131 | 60 | 2.4% |
| Other values (172) | 1519 |
| Value | Count | Frequency (%) |
| 1 | 15 | 0.6% |
| 2 | 33 | 1.3% |
| 3 | 170 | |
| 4 | 23 | 0.9% |
| 5 | 18 | 0.7% |
| 6 | 125 | |
| 7 | 96 | |
| 8 | 17 | 0.7% |
| 9 | 2 | 0.1% |
| 10 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 367 | 1 | < 0.1% |
| 364 | 5 | 0.2% |
| 359 | 1 | < 0.1% |
| 356 | 1 | < 0.1% |
| 350 | 3 | 0.1% |
| 348 | 1 | < 0.1% |
| 347 | 22 | |
| 346 | 4 | 0.2% |
| 344 | 2 | 0.1% |
| 343 | 1 | < 0.1% |
Cluster ID
Real number (ℝ)
High correlation 
| Distinct | 2190 |
|---|---|
| Distinct (%) | 88.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30377.84 |
| Minimum | 1 |
|---|---|
| Maximum | 47505 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 252.7 |
| Q1 | 6154.5 |
| median | 40693 |
| Q3 | 44098.5 |
| 95-th percentile | 46495 |
| Maximum | 47505 |
| Range | 47504 |
| Interquartile range (IQR) | 37944 |
Descriptive statistics
| Standard deviation | 18373.007 |
|---|---|
| Coefficient of variation (CV) | 0.60481611 |
| Kurtosis | -1.3491776 |
| Mean | 30377.84 |
| Median Absolute Deviation (MAD) | 3897 |
| Skewness | -0.75140668 |
| Sum | 75185153 |
| Variance | 3.3756737 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4463 | 4 | 0.2% |
| 4465 | 4 | 0.2% |
| 40467 | 4 | 0.2% |
| 44056 | 4 | 0.2% |
| 40486 | 4 | 0.2% |
| 4422 | 4 | 0.2% |
| 43292 | 3 | 0.1% |
| 46191 | 3 | 0.1% |
| 4514 | 3 | 0.1% |
| 46713 | 3 | 0.1% |
| Other values (2180) | 2439 |
| Value | Count | Frequency (%) |
| 1 | 2 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 2 | |
| 6 | 2 | |
| 7 | 2 | |
| 10 | 2 | |
| 12 | 1 | |
| 13 | 1 |
| Value | Count | Frequency (%) |
| 47505 | 1 | |
| 47459 | 1 | |
| 47445 | 1 | |
| 47440 | 1 | |
| 47434 | 1 | |
| 47427 | 1 | |
| 47426 | 1 | |
| 47395 | 1 | |
| 47362 | 1 | |
| 47348 | 1 |
Cluster Label
Text
| Distinct | 2182 |
|---|---|
| Distinct (%) | 88.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.5 KiB |
Length
| Max length | 78 |
|---|---|
| Median length | 68 |
| Mean length | 24.874343 |
| Min length | 6 |
Unique
| Unique | 1926 ? |
|---|---|
| Unique (%) | 77.8% |
Sample
| 1st row | Bosch KIL22VF30G Integrated |
|---|---|
| 2nd row | Sony KD-75XF8596 |
| 3rd row | Sony Xperia XA2 Ultra 32GB |
| 4th row | Pentax K-1 + 24-70mm |
| 5th row | Samsung UE75MU7000 |
| Value | Count | Frequency (%) |
| white | 352 | 3.8% |
| integrated | 335 | 3.6% |
| stainless | 240 | 2.6% |
| steel | 240 | 2.6% |
| bosch | 239 | 2.6% |
| intel | 183 | 2.0% |
| samsung | 180 | 1.9% |
| tray | 169 | 1.8% |
| xeon | 122 | 1.3% |
| black | 111 | 1.2% |
| Other values (2674) | 7129 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6891 | 11.2% | |
| e | 4106 | 6.7% |
| t | 2321 | 3.8% |
| n | 2090 | 3.4% |
| S | 2044 | 3.3% |
| 0 | 2021 | 3.3% |
| a | 2003 | 3.3% |
| o | 1907 | 3.1% |
| i | 1878 | 3.1% |
| s | 1598 | 2.6% |
| Other values (62) | 34705 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 61564 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 6891 | 11.2% | |
| e | 4106 | 6.7% |
| t | 2321 | 3.8% |
| n | 2090 | 3.4% |
| S | 2044 | 3.3% |
| 0 | 2021 | 3.3% |
| a | 2003 | 3.3% |
| o | 1907 | 3.1% |
| i | 1878 | 3.1% |
| s | 1598 | 2.6% |
| Other values (62) | 34705 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 61564 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 6891 | 11.2% | |
| e | 4106 | 6.7% |
| t | 2321 | 3.8% |
| n | 2090 | 3.4% |
| S | 2044 | 3.3% |
| 0 | 2021 | 3.3% |
| a | 2003 | 3.3% |
| o | 1907 | 3.1% |
| i | 1878 | 3.1% |
| s | 1598 | 2.6% |
| Other values (62) | 34705 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 61564 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 6891 | 11.2% | |
| e | 4106 | 6.7% |
| t | 2321 | 3.8% |
| n | 2090 | 3.4% |
| S | 2044 | 3.3% |
| 0 | 2021 | 3.3% |
| a | 2003 | 3.3% |
| o | 1907 | 3.1% |
| i | 1878 | 3.1% |
| s | 1598 | 2.6% |
| Other values (62) | 34705 |
Category ID
Real number (ℝ)
High correlation 
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2618.223 |
| Minimum | 2612 |
|---|---|
| Maximum | 2623 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.5 KiB |
Quantile statistics
| Minimum | 2612 |
|---|---|
| 5-th percentile | 2612 |
| Q1 | 2615 |
| median | 2619 |
| Q3 | 2622 |
| 95-th percentile | 2623 |
| Maximum | 2623 |
| Range | 11 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.6160117 |
|---|---|
| Coefficient of variation (CV) | 0.0013810938 |
| Kurtosis | -1.2040583 |
| Mean | 2618.223 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.33347018 |
| Sum | 6480102 |
| Variance | 13.075541 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2622 | 405 | |
| 2612 | 278 | |
| 2623 | 268 | |
| 2615 | 266 | |
| 2620 | 266 | |
| 2614 | 249 | |
| 2619 | 234 | |
| 2617 | 186 | |
| 2618 | 165 | |
| 2621 | 158 | 6.4% |
| Value | Count | Frequency (%) |
| 2612 | 278 | |
| 2614 | 249 | |
| 2615 | 266 | |
| 2617 | 186 | |
| 2618 | 165 | |
| 2619 | 234 | |
| 2620 | 266 | |
| 2621 | 158 | 6.4% |
| 2622 | 405 | |
| 2623 | 268 |
| Value | Count | Frequency (%) |
| 2623 | 268 | |
| 2622 | 405 | |
| 2621 | 158 | 6.4% |
| 2620 | 266 | |
| 2619 | 234 | |
| 2618 | 165 | |
| 2617 | 186 | |
| 2615 | 266 | |
| 2614 | 249 | |
| 2612 | 278 |
Category
Categorical
High correlation 
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 19.5 KiB |
| Fridge Freezers | |
|---|---|
| Mobile Phones | |
| Fridges | |
| CPUs | |
| Washing Machines | |
| Other values (5) |
Length
| Max length | 16 |
|---|---|
| Median length | 11 |
| Mean length | 10.468687 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Fridges |
|---|---|
| 2nd row | TVs |
| 3rd row | Mobile Phones |
| 4th row | Digital Cameras |
| 5th row | TVs |
Common Values
| Value | Count | Frequency (%) |
| Fridge Freezers | 405 | |
| Mobile Phones | 278 | |
| Fridges | 268 | |
| CPUs | 266 | |
| Washing Machines | 266 | |
| TVs | 249 | |
| Dishwashers | 234 | |
| Digital Cameras | 186 | |
| Microwaves | 165 | |
| Freezers | 158 | 6.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| freezers | 563 | |
| fridge | 405 | |
| mobile | 278 | |
| phones | 278 | |
| fridges | 268 | |
| cpus | 266 | |
| washing | 266 | |
| machines | 266 | |
| tvs | 249 | |
| dishwashers | 234 | |
| Other values (3) | 537 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 3769 | |
| s | 3209 | |
| r | 2384 | 9.2% |
| i | 2254 | 8.7% |
| a | 1489 | 5.7% |
| h | 1278 | 4.9% |
| F | 1236 | 4.8% |
| 1135 | 4.4% | |
| g | 1125 | 4.3% |
| n | 810 | 3.1% |
| Other values (18) | 7221 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 25910 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 3769 | |
| s | 3209 | |
| r | 2384 | 9.2% |
| i | 2254 | 8.7% |
| a | 1489 | 5.7% |
| h | 1278 | 4.9% |
| F | 1236 | 4.8% |
| 1135 | 4.4% | |
| g | 1125 | 4.3% |
| n | 810 | 3.1% |
| Other values (18) | 7221 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 25910 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 3769 | |
| s | 3209 | |
| r | 2384 | 9.2% |
| i | 2254 | 8.7% |
| a | 1489 | 5.7% |
| h | 1278 | 4.9% |
| F | 1236 | 4.8% |
| 1135 | 4.4% | |
| g | 1125 | 4.3% |
| n | 810 | 3.1% |
| Other values (18) | 7221 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 25910 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 3769 | |
| s | 3209 | |
| r | 2384 | 9.2% |
| i | 2254 | 8.7% |
| a | 1489 | 5.7% |
| h | 1278 | 4.9% |
| F | 1236 | 4.8% |
| 1135 | 4.4% | |
| g | 1125 | 4.3% |
| n | 810 | 3.1% |
| Other values (18) | 7221 |
Price
Real number (ℝ)
Skewed  Zeros 
| Distinct | 351 |
|---|---|
| Distinct (%) | 14.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 556090.5 |
| Minimum | 0 |
|---|---|
| Maximum | 4.4444435 × 108 |
| Zeros | 150 |
| Zeros (%) | 6.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 149.99 |
| median | 499.99 |
| Q3 | 999.99 |
| 95-th percentile | 1999.99 |
| Maximum | 4.4444435 × 108 |
| Range | 4.4444435 × 108 |
| Interquartile range (IQR) | 850 |
Descriptive statistics
| Standard deviation | 15474768 |
|---|---|
| Coefficient of variation (CV) | 27.827787 |
| Kurtosis | 819.93745 |
| Mean | 556090.5 |
| Median Absolute Deviation (MAD) | 399.99 |
| Skewness | 28.64401 |
| Sum | 1.376324 × 109 |
| Variance | 2.3946845 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 999.99 | 346 | 14.0% |
| 599.99 | 279 | 11.3% |
| 299.99 | 153 | 6.2% |
| 0 | 150 | 6.1% |
| 199.99 | 136 | 5.5% |
| 499.99 | 85 | 3.4% |
| 99.99 | 54 | 2.2% |
| 399.99 | 54 | 2.2% |
| 249.99 | 46 | 1.9% |
| 1000 | 41 | 1.7% |
| Other values (341) | 1131 |
| Value | Count | Frequency (%) |
| 0 | 150 | |
| 0.01 | 1 | < 0.1% |
| 2 | 3 | 0.1% |
| 2.1 | 1 | < 0.1% |
| 2.2 | 2 | 0.1% |
| 2.3 | 1 | < 0.1% |
| 2.53 | 1 | < 0.1% |
| 2.79 | 1 | < 0.1% |
| 3 | 2 | 0.1% |
| 3.33 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 444444346 | 1 | |
| 444443886 | 1 | |
| 444441110 | 1 | |
| 21000000 | 1 | |
| 12345678 | 1 | |
| 3768985 | 1 | |
| 3687772 | 1 | |
| 89999 | 1 | |
| 71700 | 1 | |
| 63003.5 | 1 |
StockQuantity
Real number (ℝ)
| Distinct | 497 |
|---|---|
| Distinct (%) | 20.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 244.85657 |
| Minimum | 0 |
|---|---|
| Maximum | 500 |
| Zeros | 3 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 26 |
| Q1 | 118 |
| median | 245 |
| Q3 | 366 |
| 95-th percentile | 472 |
| Maximum | 500 |
| Range | 500 |
| Interquartile range (IQR) | 248 |
Descriptive statistics
| Standard deviation | 143.49839 |
|---|---|
| Coefficient of variation (CV) | 0.5860508 |
| Kurtosis | -1.1985564 |
| Mean | 244.85657 |
| Median Absolute Deviation (MAD) | 124 |
| Skewness | 0.039653311 |
| Sum | 606020 |
| Variance | 20591.787 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 140 | 14 | 0.6% |
| 71 | 13 | 0.5% |
| 93 | 12 | 0.5% |
| 1 | 12 | 0.5% |
| 496 | 11 | 0.4% |
| 486 | 11 | 0.4% |
| 168 | 11 | 0.4% |
| 57 | 11 | 0.4% |
| 143 | 11 | 0.4% |
| 47 | 11 | 0.4% |
| Other values (487) | 2358 |
| Value | Count | Frequency (%) |
| 0 | 3 | 0.1% |
| 1 | 12 | |
| 2 | 6 | |
| 3 | 5 | |
| 4 | 3 | 0.1% |
| 5 | 6 | |
| 6 | 5 | |
| 7 | 2 | 0.1% |
| 8 | 6 | |
| 10 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 500 | 2 | 0.1% |
| 499 | 1 | < 0.1% |
| 498 | 7 | |
| 497 | 2 | 0.1% |
| 496 | 11 | |
| 495 | 3 | 0.1% |
| 494 | 4 | 0.2% |
| 493 | 4 | 0.2% |
| 492 | 5 | |
| 491 | 7 |
Description
Text
| Distinct | 2447 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 10 |
| Missing (%) | 0.4% |
| Memory size | 19.5 KiB |
Length
| Max length | 381 |
|---|---|
| Median length | 215 |
| Mean length | 145.95497 |
| Min length | 20 |
Unique
| Unique | 2430 ? |
|---|---|
| Unique (%) | 98.6% |
Sample
| 1st row | The Bosch Serie 4 Kil22VF30G Integrated Fridge features advanced temperature control and humidity management to provide optimal storage conditions for food, with a sleek and compact design that integrates seamlessly into any kitchen. |
|---|---|
| 2nd row | This Sony KD75XF8596BU 75“ 4K HDR Ultra HD Smart Android LED TV features integrated Amazon Alexa for seamless voice control and entertainment experiences. |
| 3rd row | The Sony Xperia XA2 Ultra Black features a 6-inch Full HD display, 32GB of internal storage, and supports 4G connectivity for seamless mobile experience. |
| 4th row | The Pentax K-1 Body is a weather-sealed digital single-lens reflex camera featuring an 24-70mm f/2.8 ED SDM WR zoom lens. |
| 5th row | This Samsung UE75MU7000TXXU is a 75-inch 7-Series LED Smart TV featuring a sleek black and silver design, equipped with advanced technologies for immersive viewing experiences. |
| Value | Count | Frequency (%) |
| a | 3386 | 6.4% |
| and | 2619 | 5.0% |
| for | 1612 | 3.1% |
| with | 1121 | 2.1% |
| this | 1104 | 2.1% |
| features | 1022 | 1.9% |
| the | 1006 | 1.9% |
| is | 1004 | 1.9% |
| featuring | 676 | 1.3% |
| advanced | 616 | 1.2% |
| Other values (5064) | 38683 |
Most occurring characters
| Value | Count | Frequency (%) |
| 50385 | ||
| e | 33089 | 9.2% |
| i | 24654 | 6.9% |
| a | 24075 | 6.7% |
| n | 20022 | 5.6% |
| r | 19066 | 5.3% |
| t | 17994 | 5.0% |
| o | 16445 | 4.6% |
| s | 16291 | 4.5% |
| c | 12921 | 3.6% |
| Other values (82) | 124837 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 359779 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 50385 | ||
| e | 33089 | 9.2% |
| i | 24654 | 6.9% |
| a | 24075 | 6.7% |
| n | 20022 | 5.6% |
| r | 19066 | 5.3% |
| t | 17994 | 5.0% |
| o | 16445 | 4.6% |
| s | 16291 | 4.5% |
| c | 12921 | 3.6% |
| Other values (82) | 124837 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 359779 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 50385 | ||
| e | 33089 | 9.2% |
| i | 24654 | 6.9% |
| a | 24075 | 6.7% |
| n | 20022 | 5.6% |
| r | 19066 | 5.3% |
| t | 17994 | 5.0% |
| o | 16445 | 4.6% |
| s | 16291 | 4.5% |
| c | 12921 | 3.6% |
| Other values (82) | 124837 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 359779 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 50385 | ||
| e | 33089 | 9.2% |
| i | 24654 | 6.9% |
| a | 24075 | 6.7% |
| n | 20022 | 5.6% |
| r | 19066 | 5.3% |
| t | 17994 | 5.0% |
| o | 16445 | 4.6% |
| s | 16291 | 4.5% |
| c | 12921 | 3.6% |
| Other values (82) | 124837 |
Rating
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5008485 |
| Minimum | 2 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 19.5 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2.1 |
| Q1 | 2.75 |
| median | 3.5 |
| Q3 | 4.3 |
| 95-th percentile | 4.8 |
| Maximum | 5 |
| Range | 3 |
| Interquartile range (IQR) | 1.55 |
Descriptive statistics
| Standard deviation | 0.87606921 |
|---|---|
| Coefficient of variation (CV) | 0.25024482 |
| Kurtosis | -1.2217046 |
| Mean | 3.5008485 |
| Median Absolute Deviation (MAD) | 0.8 |
| Skewness | 0.0099629767 |
| Sum | 8664.6 |
| Variance | 0.76749726 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.7 | 102 | 4.1% |
| 2.8 | 102 | 4.1% |
| 2.4 | 101 | 4.1% |
| 3.5 | 96 | 3.9% |
| 4.8 | 94 | 3.8% |
| 3.6 | 90 | 3.6% |
| 2.2 | 89 | 3.6% |
| 2.1 | 89 | 3.6% |
| 4.6 | 88 | 3.6% |
| 4 | 88 | 3.6% |
| Other values (21) | 1536 |
| Value | Count | Frequency (%) |
| 2 | 39 | 1.6% |
| 2.1 | 89 | |
| 2.2 | 89 | |
| 2.3 | 65 | |
| 2.4 | 101 | |
| 2.5 | 79 | |
| 2.6 | 80 | |
| 2.7 | 77 | |
| 2.8 | 102 | |
| 2.9 | 79 |
| Value | Count | Frequency (%) |
| 5 | 33 | 1.3% |
| 4.9 | 87 | |
| 4.8 | 94 | |
| 4.7 | 102 | |
| 4.6 | 88 | |
| 4.5 | 84 | |
| 4.4 | 83 | |
| 4.3 | 57 | |
| 4.2 | 82 | |
| 4.1 | 72 |
Interactions
Correlations
| Category | Category ID | Cluster ID | Merchant ID | Price | Product ID | Rating | StockQuantity | |
|---|---|---|---|---|---|---|---|---|
| Category | 1.000 | 1.000 | 0.933 | 0.286 | 0.000 | 0.891 | 0.020 | 0.000 |
| Category ID | 1.000 | 1.000 | 0.994 | 0.430 | 0.086 | 0.994 | 0.021 | -0.021 |
| Cluster ID | 0.933 | 0.994 | 1.000 | 0.447 | 0.075 | 1.000 | 0.019 | -0.020 |
| Merchant ID | 0.286 | 0.430 | 0.447 | 1.000 | 0.050 | 0.447 | -0.002 | 0.012 |
| Price | 0.000 | 0.086 | 0.075 | 0.050 | 1.000 | 0.075 | 0.010 | -0.042 |
| Product ID | 0.891 | 0.994 | 1.000 | 0.447 | 0.075 | 1.000 | 0.019 | -0.020 |
| Rating | 0.020 | 0.021 | 0.019 | -0.002 | 0.010 | 0.019 | 1.000 | -0.031 |
| StockQuantity | 0.000 | -0.021 | -0.020 | 0.012 | -0.042 | -0.020 | -0.031 | 1.000 |
Missing values
Sample
| Product ID | ProductName | Merchant ID | Cluster ID | Cluster Label | Category ID | Category | Price | StockQuantity | Description | Rating | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 43860 | bosch serie 4 kil22vf30g integrated fridge | 7 | 46162 | Bosch KIL22VF30G Integrated | 2623 | Fridges | 999.99 | 473 | The Bosch Serie 4 Kil22VF30G Integrated Fridge features advanced temperature control and humidity management to provide optimal storage conditions for food, with a sleek and compact design that integrates seamlessly into any kitchen. | 4.2 |
| 1 | 10748 | sony kd75xf8596bu 75 4k hdr ultra hd smart android led tv amazon alexa | 128 | 4465 | Sony KD-75XF8596 | 2614 | TVs | 99.99 | 335 | This Sony KD75XF8596BU 75“ 4K HDR Ultra HD Smart Android LED TV features integrated Amazon Alexa for seamless voice control and entertainment experiences. | 4.0 |
| 2 | 429 | sony xperia xa2 ultra black 6 32gb 4g unlocked sim free | 6 | 25 | Sony Xperia XA2 Ultra 32GB | 2612 | Mobile Phones | 599.99 | 490 | The Sony Xperia XA2 Ultra Black features a 6-inch Full HD display, 32GB of internal storage, and supports 4G connectivity for seamless mobile experience. | 4.7 |
| 3 | 23568 | pentax k 1 body hd 24 70mm f/2 8 ed sdm wr | 264 | 39409 | Pentax K-1 + 24-70mm | 2617 | Digital Cameras | 999.99 | 144 | The Pentax K-1 Body is a weather-sealed digital single-lens reflex camera featuring an 24-70mm f/2.8 ED SDM WR zoom lens. | 3.0 |
| 4 | 12520 | samsung ue75mu7000txxu 75 inch 7 series led smart tv black/silver | 3 | 4872 | Samsung UE75MU7000 | 2614 | TVs | 599.99 | 35 | This Samsung UE75MU7000TXXU is a 75-inch 7-Series LED Smart TV featuring a sleek black and silver design, equipped with advanced technologies for immersive viewing experiences. | 2.6 |
| 5 | 42732 | smeg pgf64 4 62cm classic 4 burner ultra low profile gas hob | 179 | 45425 | Hotpoint MTZ622NF Silver | 2622 | Fridge Freezers | 199.00 | 128 | This Smeg PGF64 4 62cm classic 4 burner ultra low profile gas hob features a sleek design and efficient cooking capabilities, making it an ideal choice for home cooks who value style and performance. | 2.1 |
| 6 | 26798 | bosch sps46iw00g 45cm serie 4 dishwasher in white 9 place settings | 128 | 40509 | Bosch SPS46IW00G White | 2619 | Dishwashers | 499.99 | 261 | The Bosch SPS46IW00G is a high-efficiency, 9-place setting dishwasher with advanced features for quiet operation and energy efficiency. | 4.8 |
| 7 | 10760 | samsung ue49nu7500 49 curved ultra hd certified hdr smart 4k tv | 32 | 4467 | Samsung UE49NU7500 | 2614 | TVs | 599.99 | 215 | This Samsung 49" Curved Ultra HD Certified HDR Smart 4K TV features cutting-edge display technology for an immersive viewing experience. | 3.2 |
| 8 | 21963 | panasonic lumix fz330 bridge camera black | 7 | 38931 | Panasonic Lumix DMC-FZ330 | 2617 | Digital Cameras | 499.99 | 223 | The Panasonic Lumix FZ330 is a compact bridge camera featuring a 20.1MP sensor, 25x optical zoom, and 4K video recording capabilities. | 2.8 |
| 9 | 1761 | lg k8 2017 smartphone 5 inch display 5mp front camera android 7.0 b | 18 | 267 | LG K8 M200N | 2612 | Mobile Phones | 500.00 | 165 | A compact Android smartphone with a 5-inch display, featuring a 5MP front camera and running on Android 7.0 operating system. | 2.6 |
| Product ID | ProductName | Merchant ID | Cluster ID | Cluster Label | Category ID | Category | Price | StockQuantity | Description | Rating | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2465 | 28269 | montpellier dw1254s 12 place dishwasher 5 progs class a silver | 147 | 40776 | Montpellier DW1254S Silver | 2619 | Dishwashers | 599.99 | 148 | This Montpellier DW1254S 12-place dishwasher features five advanced wash programs, including Class A-rated sanitization and a sleek silver finish, designed to provide efficient and hygienic cleaning for families and households of all sizes. | 2.9 |
| 2466 | 4058 | sony ericsson k800i | 48 | 1787 | Sony Ericsson K800i | 2612 | Mobile Phones | 249.99 | 402 | The Sony Ericsson K800i is a mobile phone featuring an integrated camera with a 0.3MP resolution, allowing users to capture digital photos on the go. | 4.0 |
| 2467 | 31183 | indesit iwdd7143s/iwdd7143s | 98 | 41962 | Indesit IWDD7143S | 2620 | Washing Machines | 0.00 | 489 | The Indesit IWDD7143S/IWDD7143S is a 7kg capacity, 8th generation Wi-Fi enabled washing machine featuring advanced steam cleaning technology and multiple wash cycle options. | 2.4 |
| 2468 | 38321 | liebherr ctp 2921 freestanding fridge freezer comfort | 294 | 44150 | Liebherr CTP 2921 White | 2622 | Fridge Freezers | 999.99 | 107 | The Liebherr CTP 2921 Freestanding Fridge Freezer Comfort features advanced temperature control and humidity management for optimal food storage. | 4.8 |
| 2469 | 13777 | wof processor amd ryzen 7 1700x 8 x 3.4 ghz octa c | 16 | 5851 | AMD Ryzen 7 1700X 3.4GHz Box | 2615 | CPUs | 999.00 | 289 | A high-performance computing module utilizing the AMD Ryzen 7 1700X 8-core, 3.4 GHz octa-core processor. | 4.8 |
| 2470 | 41734 | 318litre retro fridge freezer class a chilli red | 123 | 44935 | Britannia Breeze Retro Red | 2622 | Fridge Freezers | 318.00 | 97 | This 318litre retro-style fridge freezer features a Chilli Red Class A finish, perfect for adding a pop of colour to any kitchen. | 2.9 |
| 2471 | 29484 | beko dfn04c11 white full size 12 place dishwasher | 180 | 41271 | Beko DFC04C10W White | 2619 | Dishwashers | 149.99 | 456 | This Beko DFN04C11 White Full Size 12 Place Dishwasher features a high-capacity design and advanced cycle options for efficient cleaning of large families. | 2.7 |
| 2472 | 17665 | intel pentium dual core e5400 2.7ghz 800fsb socket 775 2mb 2x1mb l2 cache retail boxed processor | 121 | 7675 | Intel Pentium Dual core E5400 2 7GHz Socket 775 800MHz Box | 2615 | CPUs | 39.99 | 122 | The Intel Pentium Dual Core E5400 processor features a 2.7 GHz clock speed and 2 MB of L2 cache, packaged in a socket 775 mounting system. | 3.9 |
| 2473 | 792 | iphone xs gold 5.8 64gb 4g unlocked sim free | 6 | 60 | Apple iPhone XS 64GB | 2612 | Mobile Phones | 599.99 | 486 | A high-performance smartphone with 5.8-inch display and 64GB storage, featuring 4G connectivity and unlocked for global use. | 2.9 |
| 2474 | 37786 | bosch serie 4 integrated fridge freezer frost free in white | 31 | 44086 | Bosch KIN86VF30G Integrated | 2622 | Fridge Freezers | 999.99 | 122 | This Bosch Serie 4 integrated fridge freezer features a frost-free design and sleek, white finish, ideal for seamless integration into any kitchen decor. | 2.1 |